ION_Network with Database Manager

Issue: When upgrading ION_Network with the Database Manager, you may see a time-out message.

This time-out is due to a SQL configuration.

Resolution: Use the following workaround to resolve this and continue the upgrades:

  • Make sure you upgrade the ION_Data database first, before you upgrade the ION_Network database. This usually resolves the time-out error.
  • If you still notice the time-out error, then re-run the ION_Network upgrade.

If neither of these two options resolves the issue, then you need to modify the SQL Server Registry settings to a larger value using the Registry Editor.

Note: To change the registry setting, you must have administrative privileges.

To edit the registry:

  1. Go to Start and select Run.
  2. Type regedit in the Run text box and click OK. A Registry Editor window opens.
  3. Select Computer and press Ctrl+F. In the Find what text box, enter QueryTimeOutSeconds. The Registry Editor window highlights the QueryTimeOutSeconds registry key.
  4. Right-click the registry key and select Modify. An Edit DWORD window opens.

    Note: Before you modify Value Data, be sure you make a note of the default value data.

  5. Select the Hexadecimal option button, and set the Value Data to 258 (OR) select the Decimal option button, and set the Value Data to 600.

Once the upgrade is complete, it is recommended that you reset the registry to its original setting.

The time-out error may still prevail when there is NULL in a field that does not allow NULL. This occurs in the Name column of ION_Network.dbo.Scheduler table.

     

To correct this:

  1. Go to SQL Server Management Studio.
  2. Select File > Open File.
  3. Navigate to the \SBS Upgrade Package\SQL_Script_Files folder and open update_ Scheduler_Table.sql.

If a NULL value is found, the script will insert “-” in the Name column.